Pick list used to choose the desired kind of report that will generate.

Notes: 

• Several of the reports in the list below are sub-ledger reports and contain the words "sub-ledger" at the beginning of the description. Information on balancing sub-ledger reports, including sub-ledger reports available in other parts of the system, to the main ledger are indicated further down on this page.
• Deacom contains the ability to add unlimited user versions of any accounting report for users with permission and also the security that determines which reports each user will see in this field.

Pick list options are:

• A/P Ledger - Sub-ledger report containing Accounts Payable information by Vendor including starting balance, payments applied, and payments voided. The starting balance of the AP Ledger report will match the balance on the Purchase Order Summary report for orders received prior to the starting date specified on the pre-filter. Any field from the Cash Transactions(dtcash),Vendor Master(dmvend), and Purchase Order Header(dttput) tables can be added to the grid layout for this report.
• A/P Reconciliation - Used to track when the AP sub-ledger went out of balance. Compares values from the Trial Balance report to the total value of on hand inventory. The security setting "Accounting - View AP Reconciliation" controls the ability to see this report in the pre-filter and use the report.
• A/R Ledger - Sub-ledger report containing Accounts Receivable information by Customer including starting balance, payments received, and payments voided. The starting balance of the AR Ledger report will match the balance on the Sales Order Summary report for orders invoiced prior to the starting date specified on the pre-filter.
• A/R Reconciliation - Used to track when the AR sub-ledger went out of balance. It gives the GL and AR sub-ledger values for the accounts in the account range, for each date in the date range. The security setting "Accounting - View AR Reconciliation" controls the ability to see this report in the pre-filter and use the report.
• Anticipated Cash Receipts - Accounts Receivable information based on financial period. The report will display the number of total orders and dollars for each period as well as a running total based on how may financial periods are used/run for the report. Additional information is available via drill down capability.
• Bank Account - Displays the bank account information for the selected account. A year-end entry is required to input the beginning bank balance. If the beginning balance shows as $0.00, ensure the Completing a Year End Close process has been completed.
• Bank Reconciliation - Displays only uncleared transactions and is useful as a way of comparing what Deacom says the account balance is with what the bank statement says. The System Balance displayed on the first line will match the Balance shown in the Trial Balance. If there is a value in the Balance column on the last row, that is the difference between the Bank Statement Balance and the Deacom System Balance + any un-cleared transactions. This would indicate a discrepancy between what is in Deacom vs what is included in the Bank Statement that would need to be reviewed.
  • Example - While paying a Vendor which does decrease the bank account, if that check has not cleared the bank yet, its' total needs to be added to the Deacom balance to come up with what the actual bank account balance is. For example, assume there is currently $200 in the bank. Today a check for $50 was sent to the electric company. Logically, the balance is $150 but the bank still thinks there is $200 since they don’t know about the check yet. Once the check clears, and is marked as cleared in Deacom, the System balance and Statement balance will both show $150.
• Cash Disbursements Detail - Sub-ledger report which displays all the cash payables information, by Purchase Order, for the selected criteria. This report shows the check(s) that were used to pay for the orders displayed on the report and is helpful when multiple orders are paid with a single check. Additional Vendor information and payment type information can be added to the grid layout for this report. Separate security exists to control access to this report. Note that the "Void Transaction" button is grayed out on this report. Voiding may only be done via the Cash Disbursements Summary report since voiding will be done for the entire payment and not on a portion used to pay for one order. User Defined Fields can now be added to Payment Types on this report.
• Cash Disbursements Summary - Sub-ledger report which displays all the cash payables information for the selected criteria. Also allows users to void Purchase Order payments and add a note on why the transaction was voided. Zero dollar Purchase Orders that are marked as paid when the Vendor invoice is processed will display on the Cash Disbursements report for all accounts. Vendor address and other relevant information may be added to this report as well as the Cash Disbursements Detail report. The report displays vendor information as of the time payment was made, so that changes made to a vendor name or address after payment was made will not be changed for payments made in the past, thus allowing accurate disbursement information to be maintained for reporting purposes.
• Cash Flow - Displays estimated cash flow (cash receipts/cash expenditures) based on booked and open orders.
  • The cash flow report logic was updated to check if the lines on un-received purchase orders have different due to dock dates than the header due to dock date, and if so use the line extension for the line as the payable amount grouped in the week of the line due to dock date and will not use the PO header amount.
• Cash Receipts by Order - Sub-ledger report which displays all the cash receivable information, by Sales Order, for the selected criteria. This report shows the check(s) that were used to pay for the orders displayed on the report and is helpful when multiple orders are paid with a single check. Additional Customer information and payment type information can be added to the grid layout for this report. Separate security exists to control access to this report. Note that the "Void Transaction" button is grayed out on this report. Voiding may only be done via the Cash Receipts by Payment report since voiding will be done for the entire payment and not on a portion used to pay for one order. User Defined Fields can now be added to Payment Types on this report.
• Cash Receipts by Payment - Sub-ledger report which displays all the cash receivable information for the selected criteria. Also allows users to void Cash Receipts. The "Print" button will generate a deposit slip. The GL Account number and GL Description are available for this report as well as the Deposit Ticket report.  Customer address and other relevant information may be added to this report as well as the Cash Receipts by Order report. The report displays customer information as of the time payment was received, so that changes made to a customer name or address after payment was received will not be changed for payments received in the past, thus allowing accurate receipt information to be maintained for reporting purposes.
• Collections - Report which displays Sales Orders that are past due for collections. Only records with a Pay Schedule that have a collection date and are past due will be displayed on this report.
• Credit Details - Displays the information from the Credit tab for the selected Bill-To Companies.
  • All fields in the dmbill (Bill-To Companies) table are available to the grid in this report.
• General Ledger Detail - Displays every transaction that has ever hit the accounts, according to the selected criteria. The GL Detail report includes closing entries and all other Debits and Credits and will tie out to the Trial Balance report, as long as both are run with a start date of the first of the Fiscal Year.
  • The transactions included in this report are also how the amounts listed under the GL Summary report’s Starting Balance, Debits, and Credits are calculated, as long as the selected date range is the same.
  • This report contains a button, which acts as a toggle switch, to “Approve” or “Un-approve” transactions. This button, which is only available to this report, is more for auditing purposes since the postings have already hit the GL. Companies can control users’ ability to use this button with the security settings "Accounting -- approve transactions" and "Accounting -- unapprove transactions". The button will always be displayed, but if users do not have proper security, it will be disabled.
  • If desired, the following items are available to the grid layout of this report:
    • The identification number, (gl_usid), login name (us_login), first name (us_fname), and last name (us_lname) of the user who entered the transaction.
    • The first and last name (apprfname and apprlname, respectively) of the user who approved the transaction.
    • Purchase Order and Sales Order header fields (from the dttpur and dttord tables, respectively). While they will not be shown using the "View All Fields" button, they will be available when adding/modifying fields to the report grid.
  • The beginning and ending account balances fields may be added to the grid layout on this report. These fields are the same as the "starting" and "ending" fields on the General Ledger Summary grid layout.
• General Ledger History - GL entries according to the selected criteria along with the beginning and ending balances. The beginning and ending account balances fields may be added to the grid layout on this report. These fields are the same as the "starting" and "ending" fields on the General Ledger Summary grid layout.
• General Ledger Summary - Displays the Starting Balance, Debits, Credits, and Ending Balance of each account, according to the selected criteria. The Starting Balance column houses the closing entry transactions from the first day of the fiscal year. The Debit and Credit columns have everything that happened in the selected date range but those transactions included in the Starting Balance. The Ending Balance column is equal to (Starting Balance + Debits – Credits) and is the amount displayed on a Trial Balance report if run for the same date range.
  • The transactions that make up the amounts listed for the Starting Balance, Debits, and Credits are available via a GL Detail report for the account.
  • Double click a line to open the GL Detail report for that account.
  • In this report, all unrealized gain/loss accounts (setup via Accounting > Maintenance > Chart of Accounts) will be shown only with their associated account. The report will return no results if the GL Summary is run only with gain/loss accounts included. Note: Beginning in version 17.02.013, the system logic was enhanced. When posting to an unrealized gain account the system will first try to use the one specified on the cash account(ch_currgain), if empty the system will look to the gain/loss account on the Currency (fc_currgain), if also empty it will use gain/loss account from system options(df_currgain).
  • This report should be utilized (as opposed to the Trial Balance report) when the user is interested in running a report from the beginning of time.
  • Users should not run this report with the first of a fiscal year somewhere in the middle of the selected date range – like the Trial Balance report, having the first day of a fiscal year in the middle of the selected date range is an invalid report request, as the closing balances happening in the middle of the range will exaggerate the results.
  • The default setup of the GL Summary report shows some credit accounts as if they have a debit balance (natural balance). If users prefer, they can modify the grid to make the report show the beginning and ending balances as the actual debit or credit balance (as opposed to the natural balance) by following these steps:
    • From within a General Ledger Summary report output, click the “Modify Layout” button.
    • Select the row for the “Starting” field and click “Modify”. Change the “Field” selection from “starting” to “User-defined” and enter the following in the “User expression” field: IIF(ch_type = 'Liabilities' or ch_type = 'Revenues' or ch_type = 'Capital', starting * -1, starting).
    • Click “Save” and “Exit” to commit the changes for the “Starting” field.
    • Select the row for the “Ending” field and click “Modify”. Change the “Field” selection from “ending” to “User-defined” and enter the following in the “User expression” field: IIF(ch_type = 'Liabilities' or ch_type = 'Revenues' or ch_type = 'Capital', starting * -1, starting) + debits – credits.
    • Click “Save” and “Exit” to commit the changes for the “Ending” field.
    • Click “Save” and “Exit” to commit the changes to the grid layout. Refresh or re-run the report to see the changes.
• Inventory Reconciliation - Tracks changes and imbalances in the Inventory Sub ledger by comparing the value from the Trial Balance report to the total value of on hand inventory. The security setting "Accounting - View Inventory Reconciliation" enables users to see and select the report in the "Report type" field on the pre-filter. If this report is selected, only the "Start Date", "End Date", "Start Account", "End Account", and "Display Currency" fields will be available for selection on the pre-filter. See the "Description of calculated fields" section below for details regarding the variables in this report. The report also contains "Lots," "WIP," and "View Detail" buttons. These buttons provide the following information:
  • The "Lots" button provides sub ledger postings, for day for account, via an Inventory Lots report with the end date of the report line's date and filtered by the inventory account of the account on the report line.
  • The "WIP" button displays a lots report with a View of "WIP" and QC status of "All" based on the date range and account(s) selected on the pre-filter.
  • The "View Detail" button displays the GL detail (all postings for day for account) in the grid.
• Journal Entries - Displays all the journal entries to the GL according to the selected criteria. The "Record History" button via the More dropdown menu displays information regarding who entered the journal entry.
• Payables Detail - Sub-ledger report which displays Accounts Payable aging details according to the selected criteria on the pre-filter. This reports contains the "tp_inventered" field which displays the date the invoice was physically entered in the system. Specifically, the system will fill the "tp_inventered" field with the SQL Server date when a PO is invoiced. This date differs from the Vendor invoice and system invoice date.
• Payables Summary - Sub-ledger report which displays the Accounts Payable aging summary information according to the selected criteria on the pre-filter.
• PO Pre-Payment Summary - Groups Purchase Order prepayments by order number. Voids are cancelled out on the report and only net prepayments per order are displayed. Specifically, the report will sum up all prepayments for an order and display them as of the last date a payment was applied. If a prepayment was voided, it will not show on the report at all since it nets to zero. Users can now specify both start and end accounts for these reports, allowing for more flexibility in filtering results.
  • All dtcash, dttpur, dmvend, and the PO search names/fields are available to the report grid.
  • Added in version 17.04.008.0000
• PO Pre-Payments - Displays Purchase Orders according to the selected criteria that have prepayments. The Purchase Order prepayments account number can be found in the Accounting > Options in the Accounts Payables tab. Users can now specify both start and end accounts for these reports, allowing for more flexibility in filtering results.
  • All dtcash, dttpur, dmvend, and the PO search names/fields are available to the report grid.
  • Added in version 17.04.008.0000
• Project Reconciliation - Displays the total sales, total purchases, profit, and profit margin of a project. This report only displays a total value for received purchase orders.
• Purchase Tax - Displays the tax information, based on Tax Region for received Purchase Orders, according to the selected criteria. If there are multiple Tax Regions on the same Purchase Order, the report will display multiple lines, one for each Tax Region/order combination.
  • Total Gross - the sum of all line totals for purchase order lines that do not have a Sales Tax ID applied (lines where pu_taid = 0)
  • Taxable Amount - the sum of all line totals for any purchase order lines where the item on the line has the "PO Taxable" (pr_taxpo) flag checked.
  • Tax Amount - the line total for the line on the purchase order that has a Sales Tax ID identified (pu_taid <> 0)
• Receivables Detail - Sub-ledger report which displays Accounts Receivable aging details according to the selected criteria on the pre-filter. Note that each of the receivables reports available can also be run through Sales > Customers allowing for different pre-filter options to be used.
  • The receivables detail report contains an "Edit Data" button that allows users to modify the anticipated cash date as well as add remarks and notes to the record.
  • Additional information on the calculations in the receivables reports is available in the Description of Calculated Fields section below.
  • Terms User-Defined Fields are available to the grid in this report.
• Receivables Summary Billing Group - Sub-ledger report which displays the Accounts Receivable aging information according to the selected criteria, sorted by Billing Group.
  • All fields in the dmbill (Bill-To Companies) table, arsumbg (Accounting Reporting), ordcredit (Order Reporting), and grpmain (Billing Groups) are available to the grid in this report.
  • The security setting "Accounting -- View A/R" must be set to yes in order for users to access this report.
  • This report is available in the "Report Type" field on the Sales > Customers per-filter.
  • Two new variables/columns are available to the grid layout for this report: totdue91_120 - sums any receivables that are 91 to 120 days old. totdue121 - sums any receivables greater than 120 days old. Added to assist companies with distinguishing between receivables that are only 90 days overdue from those that are more than 120 days overdue.  120+ past due invoices may be uncollectable and may need to be categorized separately in summarized reports.
• Receivables Summary Bill-to - Sub-ledger report which displays the Accounts Receivable aging information according to the selected criteria sorted by Bill-to.
  • The following fields are available to the grid in this report: bi_name, bi_street, bi_street2, bi_city, bi_state, bi_zip, and bi_phone. These fields are helpful in situations where receivables reports are required by credit reporting agencies. Additional information on the calculations in the receivables reports is available in the Description of Calculated Fields section below.
  • This report and the Receivables Summary Ship-to report below are also available via Sales > Customers. This allows credit managers access to the appropriate information without requiring access to all the accounting reports on this page.
  • This report is available in the "Report Type" field on the Sales > Customers per-filter.
  • Two new variables/columns are available to the grid layout for this report: totdue91_120 - sums any receivables that are 91 to 120 days old. totdue121 - sums any receivables greater than 120 days old. Added to assist companies with distinguishing between receivables that are only 90 days overdue from those that are more than 120 days overdue.  120+ past due invoices may be uncollectable and may need to be categorized separately in summarized reports.
• Receivables Summary Ship-to - Sub-ledger report which displays the Accounts Receivable aging information according to the selected criteria, sorted by Ship-to Customer.
  • This report is available in the "Report Type" field on the Sales > Customers per-filter.
  • Two new variables/columns are available to the grid layout for this report: totdue91_120 - sums any receivables that are 91 to 120 days old. totdue121 - sums any receivables greater than 120 days old. Added to assist companies with distinguishing between receivables that are only 90 days overdue from those that are more than 120 days overdue.  120+ past due invoices may be uncollectable and may need to be categorized separately in summarized reports.
• Sales Tax - Displays the Sales Tax information according to the selected criteria. Note that the date pre-filters will be based on date of shipment when used with this report.
  • The Bill-to Company, Ship-to Company, and Sales Order Header fields are available to this report.
• SO Pre-Payment Summary - Groups Sales Order prepayments by order number. Voids are cancelled out on the report and only net prepayments per order are displayed. Specifically, the report will sum up all prepayments for an order and display them as of the last date a payment was applied. If a prepayment was voided, it will not show on the report at all since it nets to zero.
  • Report was recaptioned from Pre-Payment Summary to SO Pre-Payment Summary in version 17.04.008
• SO Pre-payments - Displays Sales Orders according to the selected criteria that have prepayments. The Sales Order prepayments account number can be found in the Accounting > Options in the Accounts Receivable tab.
  • Report was recaptioned from Pre-Payment Summary to SO Pre-Payment Summary in version 17.04.008
• Trial Balance - Displays a statement of the net debits and credits for each account according to the selected information. Any disagreement between the debits and credits indicates an error. The amount listed for an account on the Trial Balance report ties to the amount listed in the Ending column of a GL Summary report.
  • Double click a line to open the GL Detail report for that account.
  • The Trial Balance report has no starting or ending balance and should not be run for more than one fiscal year. This is because the first day of a new fiscal year contains closing balances that summarize the entire previous fiscal year.
  • Users should only be running a Trial Balance as Year to Date, starting with the first day of the current fiscal year and ending on the current date. This is due to closing balances being dated the first day of the fiscal year; choosing this day as anything other than the Start date will skew the results. If interested in running a report with a start date other than the first of the fiscal year, the output will be the net change in the accounts over the date range, not the balance in the balance sheet accounts. If interested in running a report from the beginning of time, refer to the GL Summary report.
• VAT Tax - Displays the VAT Tax information according to the selected criteria. Available beginning in version 16.07.001. Information on the grid includes the VAT Tax , Facility, Orders (Sales and Purchase), Total Gross, Taxable Amount, and VAT Tax Amount. If there are multiple VAT Taxes on the same order, the report will display multiple lines, one for each VAT Tax ID (va_id)/order combination.
  • Total Gross - the sum of all line totals for any sales or purchase order lines that do not have a VAT Tax applied (lines where pu_vaid or or_vaid = 0)
  • Taxable Amount - the sum of all line totals for any sales order lines where the item on the line has the "Sales Taxable" (pr_taxable) flag checked, or any purchase order lines where the item on the line has the "PO Taxable" (pr_taxpo) flag checked.
  • Tax Amount - the line total for the line on the purchase or sales order that has a VAT Tax ID identified (pu_vaid or or_vaid <> 0)

Available when using the Payables Detail, Payables Summary, Receivables Detail, Receivables Summary - Bill-to, and Receivables Summary - Ship-to Report Types. These dates are entered/maintained on the Enter Invoice Received form when entering Vendor invoices via Purchasing > Invoice. The "System Invoiced Date" represents the date the system will post the invoicing transaction to the GL. The Vendor Invoice Date represents the date that was specified on the Enter Invoiced Received form and is based on the date the invoice was received from the Vendor. This date affects the GL aging for this Vendor in connection with the payment due information specified on the terms. Options are:

• Invoice Entered
• Invoice Posting Date
• System Invoice Date
• Vendor Invoice Date

Filters for results that have a "Date Based On" selection of the date selected through the End Date, or with no End Date if that field is left blank. Not available for the following reports: Anticipated Cash Receipts, Bank Reconciliation, Cash Flow, Collections, Payables Detail, Payables Summary, Prepayment Summary, Prepayments, Receivables Detail, Receivables Summary - Bill-to, Receivables Summary - Ship-to.

Filters for results that have a "Date Based On" selection of the Start Date through the date selected, or with no Start Date if that field is left blank.

• Beginning in version 17.01.041, this field has been enhanced. When using the cash flow report type the system will honor the date set in this field as the end date for the data that is returned in the report.

First account to include in the selected report. If "Start Account" and "End Account" are left empty, all accounts display.

Last account to include in the selected report. If "Start Account" and "End Account" are left empty, all accounts display.

If a Bill-to Company is selected, only entries for the selected Bill-to Company will be displayed in the generated report.

If a Billing Group is selected, only entries for Bill-To Companies within the selected Billing Group will be displayed in the generated report.

• Only available when using the following Report Types: A/R Ledger. Collections, Receivables Detail, and Receivables Summary - Bill-To.

If a Vendor is selected, only entries for the selected Vendor will be displayed in the generated report.

If a Sales Rep is selected, only entries associated with the selected Sales Rep will be displayed in the generated report.

If an Entered By user is selected, only entries that were entered by the selected user will be displayed in the generated report.

If a Facility is selected, only entries from the selected Facility will be displayed in the generated report.

If a Facility Group is selected, only entries from Facilities within the selected Facility Group will be displayed in the generated report.

If a Payment Type is selected, only entries for the selected Payment Type will be displayed in the generated report.

If a Gift Card is selected, only entries for the selected Gift Card will be displayed in the generated report.

• This field is only available when selecting a report type of Cash Receipts by Order or Cash Receipts by Payment.

If a GL Postref is selected, only entries for the selected postref will be displayed in the generated report. A listing of postref codes is available via GL Posting Reference (postref) Codes.

For the Bank Reconciliation report, the ending statement balance.

For the Trial Balance report, determines which accounts are displayed in the generated report. Options are: 

• Accounts with Balance - Default setting, show only accounts with non-zero balances.
• Accounts with Activity - Show zero balance accounts if there was activity in the period.
• All Accounts - Show all active accounts, regardless of activity or balance.

For Payables and Receivables reports, allows the user to select by type of Payment Terms. Options are:

• All Terms - Default setting, show all receivables regardless of whether the payment terms are multiple payments or regular payments.
• Multi-Pay Terms - Show receivables with multiple Payment Terms only.
• Regular Terms - Show receivables with regular Payment Terms only.

For the General Ledger Summary report, determines if unrealized gain from transacting in foreign currencies will be hidden or displayed.

Determines if account balances will display as of the Transaction date or End date of the report being run. When set to End date, float currency conversions on balances to the end date of the report or the current date if no end date is specified. When set to Transaction date, show the balances as of the date that the transaction occurred. This applies to the GL Detail, GL Summary, Trial Balance, and Financial Statements. Note that the default selection for this field is determined by the selection in the "Balances" field on the General tab on Accounting > Options.

Allows user to select a Fiscal Year Group to be used for the starting and ending balances of the financial statement calculation.

• This searchbox is only available when Report Type is set to General Ledger Summary or General Ledger History.
• If this is left default, normal functionality using the current fiscal year will be used.

A series of question marks and dashes matching the defined Account Structure. Replace question marks with numbers to filter for all GL accounts that match the resulting mask.

Determines the currency that will be displayed in the amount columns. Select from pick list based on items setup in Accounting > Maintenance > Currencies.

If clicked, opens the Void Transaction form, allowing the user to void the selected transaction. 

• Only available for the "Cash Disbursements Summary" and "Cash Receipts by Payment" reports since voiding will be done for the entire payment and not on a portion used to pay for one order.
• Permission to use this button is controlled via the "Accounting -- void checks" security.

If clicked, generates a Sales > Order Reporting report for the invoiced orders associated with the selected line.

Generates an Accounting "Cash Receipts by Order" report for the selected record.

If clicked, generates a Purchasing > Order Reporting report for the received orders associated with the selected line.

Generates an order history report to view the order and aging history for the customer associated with the selected order.

If clicked, allows the user to modify the Anticipated Cash and Collection Dates for the selected order.

Generates an Inventory Reporting "Lots" report for the selected line.

• Only available for the "Inventory Reconciliation" report type

Generates an Inventory Reporting "WIP" report for the selected line.

• Only available for the "Inventory Reconciliation" report type

If clicked, generates a Production > Job Reporting "Job Summary" report.

• Only available for the "Project Reconciliation" report type

If clicked, generates a Purchasing > Order Reporting "Purchase Order Summary" report.

• Only available for the "Project Reconciliation" report type

Date final payment is due based on the order terms.

This date is optional and is used in connection with the "Anticipated Cash Receipts" report in Accounting Reporting, which is used to show receivables by financial period. This field may be updated at any time during the sales process, including shipment, invoicing, and after the order has been paid.

Optional field used to indicate the date a collection call should be initiated. This field is primarily designed for an order with a Payment Schedule where certain payment events/dates are set. If one of the payment dates passes and payments are not received, users may indicate a collection date to let the Accounting department know a collection call should be made.

Total order amount.

Remaining amount left to pay on the order.

Optional field to store collection notes used internally to communicate with other system users.